Pandas Profiling Report

Dataset statistics

Number of variables	22
Number of observations	21597
Missing cells	6754
Missing cells (%)	1.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.6 MiB
Average record size in memory	176.0 B

Variable types

DateTime	1
Numeric	18
Categorical	3

Alerts

`price` is highly overall correlated with `sqft_living` and 3 other fields	High correlation
`bedrooms` is highly overall correlated with `bathrooms` and 2 other fields	High correlation
`bathrooms` is highly overall correlated with `bedrooms` and 6 other fields	High correlation
`sqft_living` is highly overall correlated with `price` and 5 other fields	High correlation
`sqft_lot` is highly overall correlated with `sqft_lot15`	High correlation
`floors` is highly overall correlated with `bathrooms` and 3 other fields	High correlation
`grade` is highly overall correlated with `price` and 6 other fields	High correlation
`sqft_above` is highly overall correlated with `price` and 6 other fields	High correlation
`yr_built` is highly overall correlated with `bathrooms` and 2 other fields	High correlation
`zipcode` is highly overall correlated with `long`	High correlation
`long` is highly overall correlated with `zipcode`	High correlation
`sqft_living15` is highly overall correlated with `price` and 4 other fields	High correlation
`sqft_lot15` is highly overall correlated with `sqft_lot`	High correlation
`waterfront` is highly overall correlated with `view`	High correlation
`view` is highly overall correlated with `waterfront`	High correlation
`waterfront` is highly imbalanced (93.6%)	Imbalance
`view` is highly imbalanced (72.3%)	Imbalance
`waterfront` has 2391 (11.1%) missing values	Missing
`sqft_basement` has 452 (2.1%) missing values	Missing
`yr_renovated` has 3848 (17.8%) missing values	Missing
`id` is uniformly distributed	Uniform
`id` has unique values	Unique
`sqft_basement` has 12827 (59.4%) zeros	Zeros
`yr_renovated` has 17005 (78.7%) zeros	Zeros

Reproduction

Analysis started	2023-08-09 14:31:42.175642
Analysis finished	2023-08-09 14:32:02.334764
Duration	20.16 seconds
Software version	ydata-profiling vv4.4.0
Download configuration	config.json

date
Date

Distinct	372
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	168.9 KiB

Minimum	2014-05-02 00:00:00
Maximum	2015-05-27 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

price
Real number (ℝ)

HIGH CORRELATION

Distinct	3622
Distinct (%)	16.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	540296.57

Minimum	78000
Maximum	7700000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	78000
5-th percentile	210000
Q1	322000
median	450000
Q3	645000
95-th percentile	1160000
Maximum	7700000
Range	7622000
Interquartile range (IQR)	323000

Descriptive statistics

Standard deviation	367368.14
Coefficient of variation (CV)	0.67993794
Kurtosis	34.541359
Mean	540296.57
Median Absolute Deviation (MAD)	150000
Skewness	4.0233647
Sum	1.1668785 × 10¹⁰
Variance	1.3495935 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
450000	172	0.8%
350000	172	0.8%
550000	159	0.7%
500000	152	0.7%
425000	150	0.7%
325000	148	0.7%
400000	145	0.7%
375000	138	0.6%
300000	133	0.6%
525000	131	0.6%
Other values (3612)	20097	93.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
78000	1	< 0.1%
80000	1	< 0.1%
81000	1	< 0.1%
82000	1	< 0.1%
82500	1	< 0.1%
83000	1	< 0.1%
84000	1	< 0.1%
85000	2	< 0.1%
86500	1	< 0.1%
89000	1	< 0.1%

Value	Count	Frequency (%)
7700000	1	< 0.1%
7060000	1	< 0.1%
6890000	1	< 0.1%
5570000	1	< 0.1%
5350000	1	< 0.1%
5300000	1	< 0.1%
5110000	1	< 0.1%
4670000	1	< 0.1%
4500000	1	< 0.1%
4490000	1	< 0.1%

house_id
Real number (ℝ)

Distinct	21420
Distinct (%)	99.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5804743 × 10⁹

Minimum	1000102
Maximum	9.9000002 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	1000102
5-th percentile	5.1274039 × 10⁸
Q1	2.1230492 × 10⁹
median	3.9049304 × 10⁹
Q3	7.3089005 × 10⁹
95-th percentile	9.2973004 × 10⁹
Maximum	9.9000002 × 10⁹
Range	9.8990001 × 10⁹
Interquartile range (IQR)	5.1858513 × 10⁹

Descriptive statistics

Standard deviation	2.8767357 × 10⁹
Coefficient of variation (CV)	0.6280432
Kurtosis	-1.2607499
Mean	4.5804743 × 10⁹
Median Absolute Deviation (MAD)	2.4025303 × 10⁹
Skewness	0.24322552
Sum	9.8924503 × 10¹³
Variance	8.2756084 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
795000620	3	< 0.1%
8910500150	2	< 0.1%
7409700215	2	< 0.1%
1995200200	2	< 0.1%
9211500620	2	< 0.1%
1524079093	2	< 0.1%
4305200070	2	< 0.1%
1450100390	2	< 0.1%
7893805650	2	< 0.1%
109200390	2	< 0.1%
Other values (21410)	21576	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000102	2	< 0.1%
1200019	1	< 0.1%
1200021	1	< 0.1%
2800031	1	< 0.1%
3600057	1	< 0.1%
3600072	1	< 0.1%
3800008	1	< 0.1%
5200087	1	< 0.1%
6200017	1	< 0.1%
7200080	1	< 0.1%

Value	Count	Frequency (%)
9900000190	1	< 0.1%
9895000040	1	< 0.1%
9842300540	1	< 0.1%
9842300485	1	< 0.1%
9842300095	1	< 0.1%
9842300036	1	< 0.1%
9839301165	1	< 0.1%
9839301060	1	< 0.1%
9839301055	1	< 0.1%
9839300875	1	< 0.1%

id
Real number (ℝ)

UNIFORM UNIQUE

Distinct	21597
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10799

Minimum	1
Maximum	21597
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1080.8
Q1	5400
median	10799
Q3	16198
95-th percentile	20517.2
Maximum	21597
Range	21596
Interquartile range (IQR)	10798

Descriptive statistics

Standard deviation	6234.6612
Coefficient of variation (CV)	0.5773369
Kurtosis	-1.2
Mean	10799
Median Absolute Deviation (MAD)	5399
Skewness	0
Sum	2.33226 × 10⁸
Variance	38871000
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
14397	1	< 0.1%
14405	1	< 0.1%
14404	1	< 0.1%
14403	1	< 0.1%
14402	1	< 0.1%
14401	1	< 0.1%
14400	1	< 0.1%
14399	1	< 0.1%
14398	1	< 0.1%
Other values (21587)	21587	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
21597	1	< 0.1%
21596	1	< 0.1%
21595	1	< 0.1%
21594	1	< 0.1%
21593	1	< 0.1%
21592	1	< 0.1%
21591	1	< 0.1%
21590	1	< 0.1%
21589	1	< 0.1%
21588	1	< 0.1%

bedrooms
Real number (ℝ)

HIGH CORRELATION

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3732

Minimum	1
Maximum	33
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	33
Range	32
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.92629889
Coefficient of variation (CV)	0.27460539
Kurtosis	49.821835
Mean	3.3732
Median Absolute Deviation (MAD)	1
Skewness	2.0236412
Sum	72851
Variance	0.85802964
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	9824	45.5%
4	6882	31.9%
2	2760	12.8%
5	1601	7.4%
6	272	1.3%
1	196	0.9%
7	38	0.2%
8	13	0.1%
9	6	< 0.1%
10	3	< 0.1%
Other values (2)	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	196	0.9%
2	2760	12.8%
3	9824	45.5%
4	6882	31.9%
5	1601	7.4%
6	272	1.3%
7	38	0.2%
8	13	0.1%
9	6	< 0.1%
10	3	< 0.1%

Value	Count	Frequency (%)
33	1	< 0.1%
11	1	< 0.1%
10	3	< 0.1%
9	6	< 0.1%
8	13	0.1%
7	38	0.2%
6	272	1.3%
5	1601	7.4%
4	6882	31.9%
3	9824	45.5%

bathrooms
Real number (ℝ)

HIGH CORRELATION

Distinct	29
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1158263

Minimum	0.5
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	0.5
5-th percentile	1
Q1	1.75
median	2.25
Q3	2.5
95-th percentile	3.5
Maximum	8
Range	7.5
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.7689843
Coefficient of variation (CV)	0.36344397
Kurtosis	1.2793153
Mean	2.1158263
Median Absolute Deviation (MAD)	0.5
Skewness	0.51970928
Sum	45695.5
Variance	0.59133685
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
2.5	5377	24.9%
1	3851	17.8%
1.75	3048	14.1%
2.25	2047	9.5%
2	1930	8.9%
1.5	1445	6.7%
2.75	1185	5.5%
3	753	3.5%
3.5	731	3.4%
3.25	589	2.7%
Other values (19)	641	3.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.5	4	< 0.1%
0.75	71	0.3%
1	3851	17.8%
1.25	9	< 0.1%
1.5	1445	6.7%
1.75	3048	14.1%
2	1930	8.9%
2.25	2047	9.5%
2.5	5377	24.9%
2.75	1185	5.5%

Value	Count	Frequency (%)
8	2	< 0.1%
7.75	1	< 0.1%
7.5	1	< 0.1%
6.75	2	< 0.1%
6.5	2	< 0.1%
6.25	2	< 0.1%
6	6	< 0.1%
5.75	4	< 0.1%
5.5	10	< 0.1%
5.25	13	0.1%

sqft_living
Real number (ℝ)

HIGH CORRELATION

Distinct	1034
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2080.3219

Minimum	370
Maximum	13540
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	370
5-th percentile	940
Q1	1430
median	1910
Q3	2550
95-th percentile	3760
Maximum	13540
Range	13170
Interquartile range (IQR)	1120

Descriptive statistics

Standard deviation	918.10613
Coefficient of variation (CV)	0.44132889
Kurtosis	5.252102
Mean	2080.3219
Median Absolute Deviation (MAD)	540
Skewness	1.4732155
Sum	44928711
Variance	842918.86
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	138	0.6%
1400	135	0.6%
1440	133	0.6%
1800	129	0.6%
1660	129	0.6%
1010	129	0.6%
1820	128	0.6%
1480	125	0.6%
1720	125	0.6%
1540	124	0.6%
Other values (1024)	20302	94.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
370	1	< 0.1%
380	1	< 0.1%
390	1	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%
470	2	< 0.1%
480	2	< 0.1%

Value	Count	Frequency (%)
13540	1	< 0.1%
12050	1	< 0.1%
10040	1	< 0.1%
9890	1	< 0.1%
9640	1	< 0.1%
9200	1	< 0.1%
8670	1	< 0.1%
8020	1	< 0.1%
8010	1	< 0.1%
8000	1	< 0.1%

sqft_lot
Real number (ℝ)

HIGH CORRELATION

Distinct	9776
Distinct (%)	45.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15099.409

Minimum	520
Maximum	1651359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	520
5-th percentile	1800.8
Q1	5040
median	7618
Q3	10685
95-th percentile	43307.2
Maximum	1651359
Range	1650839
Interquartile range (IQR)	5645

Descriptive statistics

Standard deviation	41412.637
Coefficient of variation (CV)	2.7426661
Kurtosis	285.49581
Mean	15099.409
Median Absolute Deviation (MAD)	2618
Skewness	13.072604
Sum	3.2610193 × 10⁸
Variance	1.7150065 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	358	1.7%
6000	290	1.3%
4000	251	1.2%
7200	220	1.0%
4800	119	0.6%
7500	119	0.6%
4500	114	0.5%
8400	111	0.5%
9600	109	0.5%
3600	103	0.5%
Other values (9766)	19803	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
520	1	< 0.1%
572	1	< 0.1%
600	1	< 0.1%
609	1	< 0.1%
635	1	< 0.1%
638	1	< 0.1%
649	2	< 0.1%
651	1	< 0.1%
675	1	< 0.1%
676	1	< 0.1%

Value	Count	Frequency (%)
1651359	1	< 0.1%
1164794	1	< 0.1%
1074218	1	< 0.1%
1024068	1	< 0.1%
982998	1	< 0.1%
982278	1	< 0.1%
920423	1	< 0.1%
881654	1	< 0.1%
871200	2	< 0.1%
843309	1	< 0.1%

floors
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4940964

Minimum	1
Maximum	3.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1.5
Q3	2
95-th percentile	2
Maximum	3.5
Range	2.5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.53968279
Coefficient of variation (CV)	0.36121015
Kurtosis	-0.49106576
Mean	1.4940964
Median Absolute Deviation (MAD)	0.5
Skewness	0.61449698
Sum	32268
Variance	0.29125751
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	10673	49.4%
2	8235	38.1%
1.5	1910	8.8%
3	611	2.8%
2.5	161	0.7%
3.5	7	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	10673	49.4%
1.5	1910	8.8%
2	8235	38.1%
2.5	161	0.7%
3	611	2.8%
3.5	7	< 0.1%

Value	Count	Frequency (%)
3.5	7	< 0.1%
3	611	2.8%
2.5	161	0.7%
2	8235	38.1%
1.5	1910	8.8%
1	10673	49.4%

waterfront
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	2391
Missing (%)	11.1%
Memory size	168.9 KiB

0.0	19060
1.0	146

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	57618
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	19060	88.3%
1.0	146	0.7%
(Missing)	2391	11.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	19060	99.2%
1.0	146	0.8%

Most occurring characters

Value	Count	Frequency (%)
0	38266	66.4%
.	19206	33.3%
1	146	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	38412	66.7%
Other Punctuation	19206	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	38266	99.6%
1	146	0.4%

Other Punctuation

Value	Count	Frequency (%)
.	19206	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	57618	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	38266	66.4%
.	19206	33.3%
1	146	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	57618	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	38266	66.4%
.	19206	33.3%
1	146	0.3%

view
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	63
Missing (%)	0.3%
Memory size	168.9 KiB

0.0	19422
2.0	957
3.0	508
1.0	330
4.0	317

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	64602
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	19422	89.9%
2.0	957	4.4%
3.0	508	2.4%
1.0	330	1.5%
4.0	317	1.5%
(Missing)	63	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	19422	90.2%
2.0	957	4.4%
3.0	508	2.4%
1.0	330	1.5%
4.0	317	1.5%

Most occurring characters

Value	Count	Frequency (%)
0	40956	63.4%
.	21534	33.3%
2	957	1.5%
3	508	0.8%
1	330	0.5%
4	317	0.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	43068	66.7%
Other Punctuation	21534	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	40956	95.1%
2	957	2.2%
3	508	1.2%
1	330	0.8%
4	317	0.7%

Other Punctuation

Value	Count	Frequency (%)
.	21534	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	64602	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	40956	63.4%
.	21534	33.3%
2	957	1.5%
3	508	0.8%
1	330	0.5%
4	317	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	64602	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	40956	63.4%
.	21534	33.3%
2	957	1.5%
3	508	0.8%
1	330	0.5%
4	317	0.5%

condition
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	168.9 KiB

3	14020
4	5677
5	1701
2	170
1	29

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21597
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	3
3rd row	3
4th row	5
5th row	3

Common Values

Value	Count	Frequency (%)
3	14020	64.9%
4	5677	26.3%
5	1701	7.9%
2	170	0.8%
1	29	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3	14020	64.9%
4	5677	26.3%
5	1701	7.9%
2	170	0.8%
1	29	0.1%

Most occurring characters

Value	Count	Frequency (%)
3	14020	64.9%
4	5677	26.3%
5	1701	7.9%
2	170	0.8%
1	29	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	21597	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	14020	64.9%
4	5677	26.3%
5	1701	7.9%
2	170	0.8%
1	29	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	21597	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	14020	64.9%
4	5677	26.3%
5	1701	7.9%
2	170	0.8%
1	29	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21597	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	14020	64.9%
4	5677	26.3%
5	1701	7.9%
2	170	0.8%
1	29	0.1%

grade
Real number (ℝ)

HIGH CORRELATION

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6579155

Minimum	3
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	3
5-th percentile	6
Q1	7
median	7
Q3	8
95-th percentile	10
Maximum	13
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1731997
Coefficient of variation (CV)	0.15320092
Kurtosis	1.135148
Mean	7.6579155
Median Absolute Deviation (MAD)	1
Skewness	0.78823664
Sum	165388
Variance	1.3763975
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
7	8974	41.6%
8	6065	28.1%
9	2615	12.1%
6	2038	9.4%
10	1134	5.3%
11	399	1.8%
5	242	1.1%
12	89	0.4%
4	27	0.1%
13	13	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	1	< 0.1%
4	27	0.1%
5	242	1.1%
6	2038	9.4%
7	8974	41.6%
8	6065	28.1%
9	2615	12.1%
10	1134	5.3%
11	399	1.8%
12	89	0.4%

Value	Count	Frequency (%)
13	13	0.1%
12	89	0.4%
11	399	1.8%
10	1134	5.3%
9	2615	12.1%
8	6065	28.1%
7	8974	41.6%
6	2038	9.4%
5	242	1.1%
4	27	0.1%

sqft_above
Real number (ℝ)

HIGH CORRELATION

Distinct	942
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1788.5968

Minimum	370
Maximum	9410
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	370
5-th percentile	850
Q1	1190
median	1560
Q3	2210
95-th percentile	3400
Maximum	9410
Range	9040
Interquartile range (IQR)	1020

Descriptive statistics

Standard deviation	827.75976
Coefficient of variation (CV)	0.4627984
Kurtosis	3.4055198
Mean	1788.5968
Median Absolute Deviation (MAD)	450
Skewness	1.4474342
Sum	38628326
Variance	685186.22
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	212	1.0%
1010	210	1.0%
1200	206	1.0%
1220	192	0.9%
1140	184	0.9%
1400	180	0.8%
1060	178	0.8%
1180	177	0.8%
1340	176	0.8%
1250	174	0.8%
Other values (932)	19708	91.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
370	1	< 0.1%
380	1	< 0.1%
390	1	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%
470	2	< 0.1%
480	4	< 0.1%

Value	Count	Frequency (%)
9410	1	< 0.1%
8860	1	< 0.1%
8570	1	< 0.1%
8020	1	< 0.1%
7880	1	< 0.1%
7850	1	< 0.1%
7680	1	< 0.1%
7420	1	< 0.1%
7320	1	< 0.1%
6720	1	< 0.1%

sqft_basement
Real number (ℝ)

MISSING ZEROS

Distinct	303
Distinct (%)	1.4%
Missing	452
Missing (%)	2.1%
Infinite	0
Infinite (%)	0.0%
Mean	291.85722

Minimum	0
Maximum	4820
Zeros	12827
Zeros (%)	59.4%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	560
95-th percentile	1190
Maximum	4820
Range	4820
Interquartile range (IQR)	560

Descriptive statistics

Standard deviation	442.49086
Coefficient of variation (CV)	1.516121
Kurtosis	2.7036047
Mean	291.85722
Median Absolute Deviation (MAD)	0
Skewness	1.5742469
Sum	6171321
Variance	195798.16
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12827	59.4%
600	217	1.0%
700	209	1.0%
500	209	1.0%
800	201	0.9%
400	184	0.9%
1000	148	0.7%
900	142	0.7%
300	142	0.7%
200	105	0.5%
Other values (293)	6761	31.3%
(Missing)	452	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12827	59.4%
10	2	< 0.1%
20	1	< 0.1%
40	4	< 0.1%
50	11	0.1%
60	10	< 0.1%
65	1	< 0.1%
70	6	< 0.1%
80	20	0.1%
90	21	0.1%

Value	Count	Frequency (%)
4820	1	< 0.1%
4130	1	< 0.1%
3500	1	< 0.1%
3480	1	< 0.1%
3260	1	< 0.1%
3000	1	< 0.1%
2850	1	< 0.1%
2810	1	< 0.1%
2730	1	< 0.1%
2720	1	< 0.1%

yr_built
Real number (ℝ)

HIGH CORRELATION

Distinct	116
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1970.9997

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	1900
5-th percentile	1915
Q1	1951
median	1975
Q3	1997
95-th percentile	2011
Maximum	2015
Range	115
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	29.375234
Coefficient of variation (CV)	0.014903723
Kurtosis	-0.65769443
Mean	1970.9997
Median Absolute Deviation (MAD)	23
Skewness	-0.46944998
Sum	42567680
Variance	862.90438
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2014	559	2.6%
2006	453	2.1%
2005	450	2.1%
2004	433	2.0%
2003	420	1.9%
2007	417	1.9%
1977	417	1.9%
1978	387	1.8%
1968	381	1.8%
2008	367	1.7%
Other values (106)	17313	80.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1900	87	0.4%
1901	29	0.1%
1902	27	0.1%
1903	46	0.2%
1904	45	0.2%
1905	74	0.3%
1906	92	0.4%
1907	65	0.3%
1908	86	0.4%
1909	94	0.4%

Value	Count	Frequency (%)
2015	38	0.2%
2014	559	2.6%
2013	201	0.9%
2012	170	0.8%
2011	130	0.6%
2010	143	0.7%
2009	230	1.1%
2008	367	1.7%
2007	417	1.9%
2006	453	2.1%

yr_renovated
Real number (ℝ)

MISSING ZEROS

Distinct	70
Distinct (%)	0.4%
Missing	3848
Missing (%)	17.8%
Infinite	0
Infinite (%)	0.0%
Mean	836.65052

Minimum	0
Maximum	20150
Zeros	17005
Zeros (%)	78.7%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	20150
Range	20150
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	4000.1106
Coefficient of variation (CV)	4.7811009
Kurtosis	18.911492
Mean	836.65052
Median Absolute Deviation (MAD)	0
Skewness	4.572505
Sum	14849710
Variance	16000884
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	17005	78.7%
20140	73	0.3%
20130	31	0.1%
20030	31	0.1%
20070	30	0.1%
20000	29	0.1%
20050	29	0.1%
20040	22	0.1%
19900	22	0.1%
20090	21	0.1%
Other values (60)	456	2.1%
(Missing)	3848	17.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17005	78.7%
19340	1	< 0.1%
19400	2	< 0.1%
19440	1	< 0.1%
19450	3	< 0.1%
19460	1	< 0.1%
19480	1	< 0.1%
19500	1	< 0.1%
19510	1	< 0.1%
19530	1	< 0.1%

Value	Count	Frequency (%)
20150	14	0.1%
20140	73	0.3%
20130	31	0.1%
20120	8	< 0.1%
20110	9	< 0.1%
20100	15	0.1%
20090	21	0.1%
20080	15	0.1%
20070	30	0.1%
20060	20	0.1%

zipcode
Real number (ℝ)

HIGH CORRELATION

Distinct	70
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98077.952

Minimum	98001
Maximum	98199
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	98001
5-th percentile	98004
Q1	98033
median	98065
Q3	98118
95-th percentile	98177
Maximum	98199
Range	198
Interquartile range (IQR)	85

Descriptive statistics

Standard deviation	53.513072
Coefficient of variation (CV)	0.00054561776
Kurtosis	-0.85400486
Mean	98077.952
Median Absolute Deviation (MAD)	42
Skewness	0.40532219
Sum	2.1181895 × 10⁹
Variance	2863.6489
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98103	602	2.8%
98038	589	2.7%
98115	583	2.7%
98052	574	2.7%
98117	553	2.6%
98042	547	2.5%
98034	545	2.5%
98118	507	2.3%
98023	499	2.3%
98006	498	2.3%
Other values (60)	16100	74.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
98001	361	1.7%
98002	199	0.9%
98003	280	1.3%
98004	317	1.5%
98005	168	0.8%
98006	498	2.3%
98007	141	0.7%
98008	283	1.3%
98010	100	0.5%
98011	195	0.9%

Value	Count	Frequency (%)
98199	317	1.5%
98198	280	1.3%
98188	136	0.6%
98178	262	1.2%
98177	255	1.2%
98168	269	1.2%
98166	254	1.2%
98155	446	2.1%
98148	57	0.3%
98146	288	1.3%

lat
Real number (ℝ)

Distinct	5033
Distinct (%)	23.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.560093

Minimum	47.1559
Maximum	47.7776
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	47.1559
5-th percentile	47.3103
Q1	47.4711
median	47.5718
Q3	47.678
95-th percentile	47.7497
Maximum	47.7776
Range	0.6217
Interquartile range (IQR)	0.2069

Descriptive statistics

Standard deviation	0.13855177
Coefficient of variation (CV)	0.0029131938
Kurtosis	-0.67579021
Mean	47.560093
Median Absolute Deviation (MAD)	0.1049
Skewness	-0.48552159
Sum	1027155.3
Variance	0.019196592
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.5491	17	0.1%
47.6846	17	0.1%
47.5322	17	0.1%
47.6624	17	0.1%
47.6711	16	0.1%
47.6955	16	0.1%
47.6886	16	0.1%
47.6647	15	0.1%
47.6904	15	0.1%
47.686	15	0.1%
Other values (5023)	21436	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
47.1559	1	< 0.1%
47.1593	1	< 0.1%
47.1622	1	< 0.1%
47.1647	1	< 0.1%
47.1764	1	< 0.1%
47.1775	1	< 0.1%
47.1776	2	< 0.1%
47.1795	1	< 0.1%
47.1803	1	< 0.1%
47.1808	1	< 0.1%

Value	Count	Frequency (%)
47.7776	3	< 0.1%
47.7775	3	< 0.1%
47.7774	1	< 0.1%
47.7772	3	< 0.1%
47.7771	2	< 0.1%
47.777	2	< 0.1%
47.7769	3	< 0.1%
47.7768	2	< 0.1%
47.7767	6	< 0.1%
47.7766	4	< 0.1%

long
Real number (ℝ)

HIGH CORRELATION

Distinct	752
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-122.21398

Minimum	-122.519
Maximum	-121.315
Zeros	0
Zeros (%)	0.0%
Negative	21597
Negative (%)	100.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	-122.519
5-th percentile	-122.387
Q1	-122.328
median	-122.231
Q3	-122.125
95-th percentile	-121.9798
Maximum	-121.315
Range	1.204
Interquartile range (IQR)	0.203

Descriptive statistics

Standard deviation	0.14072352
Coefficient of variation (CV)	-0.0011514518
Kurtosis	1.052123
Mean	-122.21398
Median Absolute Deviation (MAD)	0.101
Skewness	0.88488948
Sum	-2639455.4
Variance	0.019803108
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.29	115	0.5%
-122.3	111	0.5%
-122.362	104	0.5%
-122.291	100	0.5%
-122.363	99	0.5%
-122.372	99	0.5%
-122.288	98	0.5%
-122.357	96	0.4%
-122.284	95	0.4%
-122.365	94	0.4%
Other values (742)	20586	95.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-122.519	1	< 0.1%
-122.515	1	< 0.1%
-122.514	1	< 0.1%
-122.512	1	< 0.1%
-122.511	2	< 0.1%
-122.509	2	< 0.1%
-122.507	1	< 0.1%
-122.506	1	< 0.1%
-122.505	3	< 0.1%
-122.504	2	< 0.1%

Value	Count	Frequency (%)
-121.315	2	< 0.1%
-121.316	1	< 0.1%
-121.319	1	< 0.1%
-121.321	1	< 0.1%
-121.325	1	< 0.1%
-121.352	2	< 0.1%
-121.359	1	< 0.1%
-121.364	2	< 0.1%
-121.402	1	< 0.1%
-121.403	1	< 0.1%

sqft_living15
Real number (ℝ)

HIGH CORRELATION

Distinct	777
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1986.6203

Minimum	399
Maximum	6210
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	399
5-th percentile	1140
Q1	1490
median	1840
Q3	2360
95-th percentile	3300
Maximum	6210
Range	5811
Interquartile range (IQR)	870

Descriptive statistics

Standard deviation	685.23047
Coefficient of variation (CV)	0.34492271
Kurtosis	1.5917328
Mean	1986.6203
Median Absolute Deviation (MAD)	410
Skewness	1.1068754
Sum	42905039
Variance	469540.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1540	197	0.9%
1440	195	0.9%
1560	192	0.9%
1500	180	0.8%
1460	169	0.8%
1580	167	0.8%
1610	166	0.8%
1720	166	0.8%
1800	166	0.8%
1620	164	0.8%
Other values (767)	19835	91.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
399	1	< 0.1%
460	2	< 0.1%
620	2	< 0.1%
670	1	< 0.1%
690	2	< 0.1%
700	2	< 0.1%
710	2	< 0.1%
720	2	< 0.1%
740	8	< 0.1%
750	3	< 0.1%

Value	Count	Frequency (%)
6210	1	< 0.1%
6110	1	< 0.1%
5790	6	< 0.1%
5610	1	< 0.1%
5600	1	< 0.1%
5500	1	< 0.1%
5380	1	< 0.1%
5340	1	< 0.1%
5330	1	< 0.1%
5220	1	< 0.1%

sqft_lot15
Real number (ℝ)

HIGH CORRELATION

Distinct	8682
Distinct (%)	40.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12758.284

Minimum	651
Maximum	871200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	168.9 KiB

Quantile statistics

Minimum	651
5-th percentile	2002.4
Q1	5100
median	7620
Q3	10083
95-th percentile	37045.2
Maximum	871200
Range	870549
Interquartile range (IQR)	4983

Descriptive statistics

Standard deviation	27274.442
Coefficient of variation (CV)	2.137783
Kurtosis	151.39566
Mean	12758.284
Median Absolute Deviation (MAD)	2505
Skewness	9.524362
Sum	2.7554065 × 10⁸
Variance	7.4389518 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	427	2.0%
4000	356	1.6%
6000	288	1.3%
7200	210	1.0%
4800	145	0.7%
7500	142	0.7%
8400	116	0.5%
3600	111	0.5%
4500	111	0.5%
5100	109	0.5%
Other values (8672)	19582	90.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
651	1	< 0.1%
659	1	< 0.1%
660	1	< 0.1%
748	2	< 0.1%
750	4	< 0.1%
755	1	< 0.1%
757	1	< 0.1%
758	1	< 0.1%
788	1	< 0.1%
794	1	< 0.1%

Value	Count	Frequency (%)
871200	1	< 0.1%
858132	1	< 0.1%
560617	1	< 0.1%
438213	1	< 0.1%
434728	1	< 0.1%
425581	1	< 0.1%
422967	1	< 0.1%
411962	1	< 0.1%
392040	2	< 0.1%
386812	1	< 0.1%

Auto

Heatmap
Table

	price	house_id	id	bedrooms	bathrooms	sqft_living	sqft_lot	floors	grade	sqft_above	sqft_basement	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15	waterfront	view	condition
price	1.000	0.004	0.040	0.344	0.497	0.644	0.075	0.322	0.658	0.542	0.252	0.102	0.106	-0.009	0.456	0.064	0.572	0.063	0.333	0.207	0.023
house_id	0.004	1.000	0.005	0.006	0.015	0.002	-0.117	0.019	0.020	0.004	0.002	0.027	-0.013	-0.005	-0.004	0.007	0.000	-0.115	0.006	0.029	0.030
id	0.040	0.005	1.000	0.012	0.113	0.044	-0.135	0.171	0.094	0.069	-0.034	0.229	-0.023	0.000	-0.004	0.001	0.019	-0.130	0.015	0.017	0.111
bedrooms	0.344	0.006	0.012	1.000	0.521	0.648	0.217	0.228	0.380	0.540	0.230	0.181	0.014	-0.168	-0.022	0.193	0.444	0.202	0.016	0.038	0.012
bathrooms	0.497	0.015	0.113	0.521	1.000	0.746	0.069	0.548	0.658	0.691	0.191	0.568	0.042	-0.205	0.008	0.262	0.571	0.064	0.109	0.111	0.122
sqft_living	0.644	0.002	0.044	0.648	0.746	1.000	0.305	0.401	0.716	0.843	0.328	0.353	0.053	-0.207	0.031	0.285	0.747	0.285	0.151	0.147	0.056
sqft_lot	0.075	-0.117	-0.135	0.217	0.069	0.305	1.000	-0.234	0.152	0.273	0.036	-0.037	0.005	-0.319	-0.122	0.371	0.360	0.922	0.022	0.041	0.040
floors	0.322	0.019	0.171	0.228	0.548	0.401	-0.234	1.000	0.502	0.599	-0.272	0.551	0.009	-0.062	0.024	0.149	0.306	-0.231	0.017	0.022	0.178
grade	0.658	0.020	0.094	0.380	0.658	0.716	0.152	0.502	1.000	0.712	0.093	0.501	0.018	-0.182	0.104	0.223	0.663	0.157	0.129	0.142	0.128
sqft_above	0.542	0.004	0.069	0.540	0.691	0.843	0.273	0.599	0.712	1.000	-0.166	0.472	0.029	-0.279	-0.026	0.386	0.697	0.255	0.084	0.089	0.106
sqft_basement	0.252	0.002	-0.034	0.230	0.191	0.328	0.036	-0.272	0.093	-0.166	1.000	-0.178	0.065	0.115	0.116	-0.201	0.130	0.030	0.146	0.159	0.092
yr_built	0.102	0.027	0.229	0.181	0.568	0.353	-0.037	0.551	0.501	0.472	-0.178	1.000	-0.216	-0.317	-0.126	0.413	0.336	-0.016	0.035	0.042	0.248
yr_renovated	0.106	-0.013	-0.023	0.014	0.042	0.053	0.005	0.009	0.018	0.029	0.065	-0.216	1.000	0.068	0.028	-0.080	-0.004	0.005	0.085	0.106	0.069
zipcode	-0.009	-0.005	0.000	-0.168	-0.205	-0.207	-0.319	-0.062	-0.182	-0.279	0.115	-0.317	0.068	1.000	0.249	-0.577	-0.287	-0.326	0.079	0.074	0.074
lat	0.456	-0.004	-0.004	-0.022	0.008	0.031	-0.122	0.024	0.104	-0.026	0.116	-0.126	0.028	0.249	1.000	-0.143	0.027	-0.116	0.033	0.068	0.057
long	0.064	0.007	0.001	0.193	0.262	0.285	0.371	0.149	0.223	0.386	-0.201	0.413	-0.080	-0.577	-0.143	1.000	0.381	0.373	0.092	0.085	0.081
sqft_living15	0.572	0.000	0.019	0.444	0.571	0.747	0.360	0.306	0.663	0.697	0.130	0.336	-0.004	-0.287	0.027	0.381	1.000	0.366	0.092	0.147	0.062
sqft_lot15	0.063	-0.115	-0.130	0.202	0.064	0.285	0.922	-0.231	0.157	0.255	0.030	-0.016	0.005	-0.326	-0.116	0.373	0.366	1.000	0.000	0.035	0.013
waterfront	0.333	0.006	0.015	0.016	0.109	0.151	0.022	0.017	0.129	0.084	0.146	0.035	0.085	0.079	0.033	0.092	0.092	0.000	1.000	0.600	0.019
view	0.207	0.029	0.017	0.038	0.111	0.147	0.041	0.022	0.142	0.089	0.159	0.042	0.106	0.074	0.068	0.085	0.147	0.035	0.600	1.000	0.025
condition	0.023	0.030	0.111	0.012	0.122	0.056	0.040	0.178	0.128	0.106	0.092	0.248	0.069	0.074	0.057	0.081	0.062	0.013	0.019	0.025	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	date	price	house_id	id	bedrooms	bathrooms	sqft_living	sqft_lot	floors	waterfront	view	condition	grade	sqft_above	sqft_basement	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15
0	2014-10-13	221900.000	7129300520	1	3.000	1.000	1180.000	5650.000	1.000	NaN	0.000	3	7	1180.000	0.000	1955	0.000	98178	47.511	-122.257	1340.000	5650.000
1	2014-12-09	538000.000	6414100192	2	3.000	2.250	2570.000	7242.000	2.000	0.000	0.000	3	7	2170.000	400.000	1951	19910.000	98125	47.721	-122.319	1690.000	7639.000
2	2015-02-25	180000.000	5631500400	3	2.000	1.000	770.000	10000.000	1.000	0.000	0.000	3	6	770.000	0.000	1933	NaN	98028	47.738	-122.233	2720.000	8062.000
3	2014-12-09	604000.000	2487200875	4	4.000	3.000	1960.000	5000.000	1.000	0.000	0.000	5	7	1050.000	910.000	1965	0.000	98136	47.521	-122.393	1360.000	5000.000
4	2015-02-18	510000.000	1954400510	5	3.000	2.000	1680.000	8080.000	1.000	0.000	0.000	3	8	1680.000	0.000	1987	0.000	98074	47.617	-122.045	1800.000	7503.000
5	2014-05-12	1230000.000	7237550310	6	4.000	4.500	5420.000	101930.000	1.000	0.000	0.000	3	11	3890.000	1530.000	2001	0.000	98053	47.656	-122.005	4760.000	101930.000
6	2014-06-27	257500.000	1321400060	7	3.000	2.250	1715.000	6819.000	2.000	0.000	0.000	3	7	1715.000	NaN	1995	0.000	98003	47.310	-122.327	2238.000	6819.000
7	2015-01-15	291850.000	2008000270	8	3.000	1.500	1060.000	9711.000	1.000	0.000	NaN	3	7	1060.000	0.000	1963	0.000	98198	47.410	-122.315	1650.000	9711.000
8	2015-04-15	229500.000	2414600126	9	3.000	1.000	1780.000	7470.000	1.000	0.000	0.000	3	7	1050.000	730.000	1960	0.000	98146	47.512	-122.337	1780.000	8113.000
9	2015-03-12	323000.000	3793500160	10	3.000	2.500	1890.000	6560.000	2.000	0.000	0.000	3	7	1890.000	0.000	2003	0.000	98038	47.368	-122.031	2390.000	7570.000

	date	price	house_id	id	bedrooms	bathrooms	sqft_living	sqft_lot	floors	waterfront	view	condition	grade	sqft_above	sqft_basement	yr_built	zipcode	lat	long	sqft_living15	sqft_lot15
21587	2014-08-25	507250.000	7852140040	21588	3.000	2.500	2270.000	5536.000	2.000	NaN	0.000	3	8	2270.000	0.000	2003	98065	47.539	-121.881	2270.000	5731.000
21588	2015-01-26	429000.000	9834201367	21589	3.000	2.000	1490.000	1126.000	3.000	0.000	0.000	3	8	1490.000	0.000	2014	98144	47.570	-122.288	1400.000	1230.000
21589	2014-10-14	610685.000	3448900210	21590	4.000	2.500	2520.000	6023.000	2.000	0.000	NaN	3	9	2520.000	0.000	2014	98056	47.514	-122.167	2520.000	6023.000
21590	2015-03-26	1010000.000	7936000429	21591	4.000	3.500	3510.000	7200.000	2.000	0.000	0.000	3	9	2600.000	910.000	2009	98136	47.554	-122.398	2050.000	6200.000
21591	2015-02-19	475000.000	2997800021	21592	3.000	2.500	1310.000	1294.000	2.000	0.000	0.000	3	8	1180.000	130.000	2008	98116	47.577	-122.409	1330.000	1265.000
21592	2014-05-21	360000.000	263000018	21593	3.000	2.500	1530.000	1131.000	3.000	0.000	0.000	3	8	1530.000	0.000	2009	98103	47.699	-122.346	1530.000	1509.000
21593	2015-02-23	400000.000	6600060120	21594	4.000	2.500	2310.000	5813.000	2.000	0.000	0.000	3	8	2310.000	0.000	2014	98146	47.511	-122.362	1830.000	7200.000
21594	2014-06-23	402101.000	1523300141	21595	2.000	0.750	1020.000	1350.000	2.000	0.000	0.000	3	7	1020.000	0.000	2009	98144	47.594	-122.299	1020.000	2007.000
21595	2015-01-16	400000.000	291310100	21596	3.000	2.500	1600.000	2388.000	2.000	NaN	0.000	3	8	1600.000	0.000	2004	98027	47.535	-122.069	1410.000	1287.000
21596	2014-10-15	325000.000	1523300157	21597	2.000	0.750	1020.000	1076.000	2.000	0.000	0.000	3	7	1020.000	0.000	2008	98144	47.594	-122.299	1020.000	1357.000

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample